﻿using ReflectionStudio.Core;
using ReflectionStudio.Core.Events;
using System;
using System.Collections.Generic;
using System.Data;
using WPFExcelReport.Helpers;
using System.Data.OracleClient;
using System.IO;
using INTEX.DataBase.Tools;
namespace WPFExcelReport
{
    public partial class YCAEKAUDITReport : BaseReport
    { 
 
        
        private void FillInPOEXCEL(DataRow row)
        {
            try
            {
                string value = "";
                Dictionary<string, int> colorpos = new Dictionary<string, int>();
                int x = 1, y = 1;
                x = 5; y = 18;
                //exAgent.SetCellsPicture(5, 17, @"D:\DS40\A1.jpg"); 
                value = row["EKKAUFKRS"].ToString() + "-" + row["EKKAUFLFD"].ToString();
                exAgent.SetCellValue(x, y, value);
                x = 3; y = 30;
                exAgent.SetCellValue(x, y, date);
                int rown = FillInEKPOS();  
                FillinSing(2260);
                FillInQPPlan(2106);
                exAgent.DeleteRows(rown, 2100);
            }
            catch (Exception ex)
            {
                Tracer.Error(ex.StackTrace, ex);
            }
        } 
      
    }
}